package com.hos.db.create.relation;

/**
 * 关系
 * Created by guom on 2018/10/15.
 */
public class RelationTable {
    public static String tableName = "relation";
    public static String tableRelationId = "relation_id";//关系id
    public static String tableDocId = "doc_id";//医生id
    public static String tablePatId = "pat_id";//患者id
    public static String tablePatRemark = "pat_remark";//备注患者
    public static String tablePatRemarkImages = "pat_remark_images";//备注患者图片

    public static String tableDocRemark = "doc_remark";//备注医生
    public static String tableRelationUpdateTime = "relation_update_time";

    public static String tableRelationCreateTime = "relation_create_time";// 消息创建时间
    //
    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableRelationId + "  varchar(200) primary key , "//主键
            + tableDocId + " varchar(200), "
            + tablePatId + " varchar(100),"
            + tablePatRemark + " varchar(100),"
            + tablePatRemarkImages + " longText,"
            + tableDocRemark + " varchar(100),"
            + tableRelationUpdateTime + " datetime, "
            + tableRelationCreateTime + " datetime "
            + "); ";

}
